﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="AllFieldsLibrary" targetNamespace="http://tempuri.org/AllFieldsLibrary.xsd" xmlns:mstns="http://tempuri.org/AllFieldsLibrary.xsd" xmlns="http://tempuri.org/AllFieldsLibrary.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="usersConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="usersConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.UIModule.Properties.Settings.GlobalReference.Default.usersConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="autorTableAdapter" GeneratorDataComponentClassName="autorTableAdapter" Name="autor" UserDataComponentName="autorTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="usersConnectionString (Settings)" DbObjectName="library.dbo.autor" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[autor] WHERE (([idAutor] = @Original_idAutor) AND ([numeAutor] = @Original_numeAutor) AND ([prenumeAutor] = @Original_prenumeAutor))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idAutor" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idAutor" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_numeAutor" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="numeAutor" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_prenumeAutor" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="prenumeAutor" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[autor] ([numeAutor], [prenumeAutor]) VALUES (@numeAutor, @prenumeAutor);
SELECT idAutor, numeAutor, prenumeAutor FROM autor WHERE (idAutor = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@numeAutor" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="numeAutor" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@prenumeAutor" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="prenumeAutor" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT idAutor, numeAutor, prenumeAutor FROM dbo.autor</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[autor] SET [numeAutor] = @numeAutor, [prenumeAutor] = @prenumeAutor WHERE (([idAutor] = @Original_idAutor) AND ([numeAutor] = @Original_numeAutor) AND ([prenumeAutor] = @Original_prenumeAutor));
SELECT idAutor, numeAutor, prenumeAutor FROM autor WHERE (idAutor = @idAutor)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@numeAutor" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="numeAutor" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@prenumeAutor" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="prenumeAutor" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idAutor" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idAutor" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_numeAutor" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="numeAutor" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_prenumeAutor" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="prenumeAutor" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="idAutor" ColumnName="idAutor" DataSourceName="library.dbo.autor" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@idAutor" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="idAutor" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="idAutor" DataSetColumn="idAutor" />
              <Mapping SourceColumn="numeAutor" DataSetColumn="numeAutor" />
              <Mapping SourceColumn="prenumeAutor" DataSetColumn="prenumeAutor" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="autorProdusTableAdapter" GeneratorDataComponentClassName="autorProdusTableAdapter" Name="autorProdus" UserDataComponentName="autorProdusTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="usersConnectionString (Settings)" DbObjectName="library.dbo.autorProdus" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[autorProdus] ([idAutor]) VALUES (@idAutor)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idAutor" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idAutor" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT idProdus, idAutor FROM dbo.autorProdus</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="idProdus" DataSetColumn="idProdus" />
              <Mapping SourceColumn="idAutor" DataSetColumn="idAutor" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="carteRevistaTableAdapter" GeneratorDataComponentClassName="carteRevistaTableAdapter" Name="carteRevista" UserDataComponentName="carteRevistaTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="usersConnectionString (Settings)" DbObjectName="library.dbo.carteRevista" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[carteRevista] WHERE (([idCarteRevista] = @Original_idCarteRevista) AND ([idProdus] = @Original_idProdus) AND ([nrPagini] = @Original_nrPagini))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idCarteRevista" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idCarteRevista" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idProdus" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idProdus" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nrPagini" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nrPagini" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[carteRevista] ([idProdus], [nrPagini]) VALUES (@idProdus, @nrPagini);
SELECT idCarteRevista, idProdus, nrPagini FROM carteRevista WHERE (idCarteRevista = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idProdus" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idProdus" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@nrPagini" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nrPagini" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT idCarteRevista, idProdus, nrPagini FROM dbo.carteRevista</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[carteRevista] SET [idProdus] = @idProdus, [nrPagini] = @nrPagini WHERE (([idCarteRevista] = @Original_idCarteRevista) AND ([idProdus] = @Original_idProdus) AND ([nrPagini] = @Original_nrPagini));
SELECT idCarteRevista, idProdus, nrPagini FROM carteRevista WHERE (idCarteRevista = @idCarteRevista)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idProdus" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idProdus" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@nrPagini" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nrPagini" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idCarteRevista" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idCarteRevista" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idProdus" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idProdus" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nrPagini" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nrPagini" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="idCarteRevista" ColumnName="idCarteRevista" DataSourceName="library.dbo.carteRevista" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@idCarteRevista" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="idCarteRevista" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="idCarteRevista" DataSetColumn="idCarteRevista" />
              <Mapping SourceColumn="idProdus" DataSetColumn="idProdus" />
              <Mapping SourceColumn="nrPagini" DataSetColumn="nrPagini" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="detaliiProdusTableAdapter" GeneratorDataComponentClassName="detaliiProdusTableAdapter" Name="detaliiProdus" UserDataComponentName="detaliiProdusTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="usersConnectionString (Settings)" DbObjectName="library.dbo.detaliiProdus" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[detaliiProdus] WHERE (([idProdus] = @Original_idProdus) AND ([titlu] = @Original_titlu) AND ([producator] = @Original_producator) AND ([idTipProdus] = @Original_idTipProdus) AND ([idDomeniu] = @Original_idDomeniu) AND ([anAparitie] = @Original_anAparitie) AND ((@IsNull_imagine = 1 AND [imagine] IS NULL) OR ([imagine] = @Original_imagine)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idProdus" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idProdus" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_titlu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="titlu" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_producator" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="producator" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idTipProdus" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idTipProdus" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idDomeniu" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idDomeniu" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_anAparitie" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="anAparitie" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_imagine" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="imagine" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_imagine" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="imagine" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[detaliiProdus] ([titlu], [producator], [idTipProdus], [idDomeniu], [anAparitie], [descriere], [imagine]) VALUES (@titlu, @producator, @idTipProdus, @idDomeniu, @anAparitie, @descriere, @imagine);
SELECT idProdus, titlu, producator, idTipProdus, idDomeniu, anAparitie, descriere, imagine FROM detaliiProdus WHERE (idProdus = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@titlu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="titlu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@producator" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="producator" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idTipProdus" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idTipProdus" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idDomeniu" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idDomeniu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@anAparitie" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="anAparitie" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@descriere" Precision="0" ProviderType="Text" Scale="0" Size="0" SourceColumn="descriere" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@imagine" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="imagine" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT idProdus, titlu, autor, producator, idTipProdus, idDomeniu, anAparitie, descriere, imagine FROM dbo.detaliiProdus</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[detaliiProdus] SET [titlu] = @titlu, [autor] = @autor, [producator] = @producator, [idTipProdus] = @idTipProdus, [idDomeniu] = @idDomeniu, [anAparitie] = @anAparitie, [descriere] = @descriere, [imagine] = @imagine WHERE (([idProdus] = @Original_idProdus) AND ([titlu] = @Original_titlu) AND ([producator] = @Original_producator) AND ([idTipProdus] = @Original_idTipProdus) AND ([idDomeniu] = @Original_idDomeniu) AND ([anAparitie] = @Original_anAparitie) AND ((@IsNull_imagine = 1 AND [imagine] IS NULL) OR ([imagine] = @Original_imagine)));
SELECT idProdus, titlu, autor, producator, idTipProdus, idDomeniu, anAparitie, descriere, imagine FROM detaliiProdus WHERE (idProdus = @idProdus)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@titlu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="titlu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@autor" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="autor" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@producator" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="producator" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idTipProdus" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idTipProdus" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idDomeniu" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idDomeniu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@anAparitie" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="anAparitie" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@descriere" Precision="0" ProviderType="Text" Scale="0" Size="0" SourceColumn="descriere" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@imagine" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="imagine" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idProdus" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idProdus" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_titlu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="titlu" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_producator" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="producator" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idTipProdus" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idTipProdus" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idDomeniu" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idDomeniu" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_anAparitie" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="anAparitie" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_imagine" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="imagine" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_imagine" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="imagine" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="idProdus" ColumnName="idProdus" DataSourceName="library.dbo.detaliiProdus" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@idProdus" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="idProdus" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="idProdus" DataSetColumn="idProdus" />
              <Mapping SourceColumn="titlu" DataSetColumn="titlu" />
              <Mapping SourceColumn="producator" DataSetColumn="producator" />
              <Mapping SourceColumn="idTipProdus" DataSetColumn="idTipProdus" />
              <Mapping SourceColumn="idDomeniu" DataSetColumn="idDomeniu" />
              <Mapping SourceColumn="anAparitie" DataSetColumn="anAparitie" />
              <Mapping SourceColumn="descriere" DataSetColumn="descriere" />
              <Mapping SourceColumn="imagine" DataSetColumn="imagine" />
              <Mapping SourceColumn="autor" DataSetColumn="autor" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="usersConnectionString (Settings)" DbObjectName="library.dbo.detaliiProdus" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="GetAvailableItems" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataBy2" GeneratorSourceName="GetAvailableItems" GetMethodModifier="Public" GetMethodName="GetDataBy2" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy2" UserSourceName="GetAvailableItems">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        detaliiProdus.idProdus, detaliiProdus.titlu, detaliiProdus.autor, detaliiProdus.producator, detaliiProdus.anAparitie, detaliiProdus.descriere, 
                         stareProdus.stareProdus
FROM            detaliiProdus INNER JOIN
                         exemplar ON detaliiProdus.idProdus = exemplar.idProdus AND exemplar.ptImprumutat = 1 INNER JOIN
                         stareProdus ON exemplar.idStareProdus = stareProdus.idStareProdus</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="usersConnectionString (Settings)" DbObjectName="library.dbo.detaliiProdus" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="GetUnavailableItems" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataBy3" GeneratorSourceName="GetUnavailableItems" GetMethodModifier="Public" GetMethodName="GetDataBy3" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy3" UserSourceName="GetUnavailableItems">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        detaliiProdus.idProdus, detaliiProdus.titlu, detaliiProdus.autor, detaliiProdus.producator, detaliiProdus.anAparitie, detaliiProdus.descriere
FROM            detaliiProdus INNER JOIN
                         exemplar ON detaliiProdus.idProdus = exemplar.idProdus AND exemplar.ptImprumutat = 0</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="usersConnectionString (Settings)" DbObjectName="library.dbo.detaliiProdus" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="SelectByAuthor" GenerateMethods="Fill" GenerateShortCommands="true" GeneratorSourceName="SelectByAuthor" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="SelectByAuthor">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        anAparitie, autor, descriere, idDomeniu, idProdus, idTipProdus, imagine, producator, titlu
FROM            detaliiProdus
WHERE        (autor LIKE '%' + @authorName + '%')</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="authorName" ColumnName="autor" DataSourceName="library.dbo.detaliiProdus" DataTypeServer="nvarchar(MAX)" DbType="String" Direction="Input" ParameterName="@authorName" Precision="0" ProviderType="NVarChar" Scale="0" Size="2147483647" SourceColumn="autor" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="usersConnectionString (Settings)" DbObjectName="library.dbo.detaliiProdus" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="SelectByTitle" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataBy1" GeneratorSourceName="SelectByTitle" GetMethodModifier="Public" GetMethodName="GetDataBy1" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="SelectByTitle">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        anAparitie, autor, descriere, idDomeniu, idProdus, idTipProdus, imagine, producator, titlu
FROM            detaliiProdus
WHERE        (titlu LIKE @titleName + '%')</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="titleName" ColumnName="titlu" DataSourceName="library.dbo.detaliiProdus" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@titleName" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="titlu" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="domeniuTableAdapter" GeneratorDataComponentClassName="domeniuTableAdapter" Name="domeniu" UserDataComponentName="domeniuTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="usersConnectionString (Settings)" DbObjectName="library.dbo.domeniu" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[domeniu] WHERE (([idDomeniu] = @Original_idDomeniu) AND ([numeDomeniu] = @Original_numeDomeniu))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idDomeniu" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idDomeniu" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_numeDomeniu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="numeDomeniu" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[domeniu] ([numeDomeniu]) VALUES (@numeDomeniu);
SELECT idDomeniu, numeDomeniu FROM domeniu WHERE (idDomeniu = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@numeDomeniu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="numeDomeniu" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT idDomeniu, numeDomeniu FROM dbo.domeniu</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[domeniu] SET [numeDomeniu] = @numeDomeniu WHERE (([idDomeniu] = @Original_idDomeniu) AND ([numeDomeniu] = @Original_numeDomeniu));
SELECT idDomeniu, numeDomeniu FROM domeniu WHERE (idDomeniu = @idDomeniu)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@numeDomeniu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="numeDomeniu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idDomeniu" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idDomeniu" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_numeDomeniu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="numeDomeniu" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="idDomeniu" ColumnName="idDomeniu" DataSourceName="library.dbo.domeniu" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@idDomeniu" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="idDomeniu" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="idDomeniu" DataSetColumn="idDomeniu" />
              <Mapping SourceColumn="numeDomeniu" DataSetColumn="numeDomeniu" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="exemplarTableAdapter" GeneratorDataComponentClassName="exemplarTableAdapter" Name="exemplar" UserDataComponentName="exemplarTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="usersConnectionString (Settings)" DbObjectName="library.dbo.exemplar" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[exemplar] WHERE (([idExemplar] = @Original_idExemplar) AND ([idProdus] = @Original_idProdus) AND ([idStareProdus] = @Original_idStareProdus) AND ([ptImprumutat] = @Original_ptImprumutat) AND ([pret] = @Original_pret) AND ([inStoc] = @Original_inStoc))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idExemplar" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idExemplar" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idProdus" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idProdus" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idStareProdus" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idStareProdus" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_ptImprumutat" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ptImprumutat" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_pret" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="pret" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_inStoc" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="inStoc" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[exemplar] ([idExemplar], [idProdus], [idStareProdus], [ptImprumutat], [pret], [inStoc]) VALUES (@idExemplar, @idProdus, @idStareProdus, @ptImprumutat, @pret, @inStoc);
SELECT idExemplar, idProdus, idStareProdus, ptImprumutat, pret, inStoc FROM exemplar WHERE (idExemplar = @idExemplar)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idExemplar" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idExemplar" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idProdus" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idProdus" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idStareProdus" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idStareProdus" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@ptImprumutat" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ptImprumutat" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@pret" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="pret" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@inStoc" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="inStoc" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT idExemplar, idProdus, idStareProdus, ptImprumutat, pret, inStoc FROM dbo.exemplar</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[exemplar] SET [idExemplar] = @idExemplar, [idProdus] = @idProdus, [idStareProdus] = @idStareProdus, [ptImprumutat] = @ptImprumutat, [pret] = @pret, [inStoc] = @inStoc WHERE (([idExemplar] = @Original_idExemplar) AND ([idProdus] = @Original_idProdus) AND ([idStareProdus] = @Original_idStareProdus) AND ([ptImprumutat] = @Original_ptImprumutat) AND ([pret] = @Original_pret) AND ([inStoc] = @Original_inStoc));
SELECT idExemplar, idProdus, idStareProdus, ptImprumutat, pret, inStoc FROM exemplar WHERE (idExemplar = @idExemplar)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idExemplar" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idExemplar" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idProdus" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idProdus" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idStareProdus" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idStareProdus" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@ptImprumutat" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ptImprumutat" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@pret" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="pret" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@inStoc" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="inStoc" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idExemplar" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idExemplar" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idProdus" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idProdus" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idStareProdus" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idStareProdus" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_ptImprumutat" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ptImprumutat" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_pret" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="pret" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_inStoc" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="inStoc" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="idExemplar" DataSetColumn="idExemplar" />
              <Mapping SourceColumn="idProdus" DataSetColumn="idProdus" />
              <Mapping SourceColumn="idStareProdus" DataSetColumn="idStareProdus" />
              <Mapping SourceColumn="ptImprumutat" DataSetColumn="ptImprumutat" />
              <Mapping SourceColumn="pret" DataSetColumn="pret" />
              <Mapping SourceColumn="inStoc" DataSetColumn="inStoc" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="istoricUtilizatoriTableAdapter" GeneratorDataComponentClassName="istoricUtilizatoriTableAdapter" Name="istoricUtilizatori" UserDataComponentName="istoricUtilizatoriTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="usersConnectionString (Settings)" DbObjectName="library.dbo.istoricUtilizatori" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[istoricUtilizatori] WHERE (([idIstoric] = @Original_idIstoric) AND ([idUtilizator] = @Original_idUtilizator) AND ([dataInregistrare] = @Original_dataInregistrare) AND ((@IsNull_dataStergere = 1 AND [dataStergere] IS NULL) OR ([dataStergere] = @Original_dataStergere)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idIstoric" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idIstoric" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idUtilizator" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idUtilizator" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_dataInregistrare" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="dataInregistrare" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dataStergere" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dataStergere" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_dataStergere" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="dataStergere" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[istoricUtilizatori] ([idUtilizator], [dataInregistrare], [dataStergere]) VALUES (@idUtilizator, @dataInregistrare, @dataStergere);
SELECT idIstoric, idUtilizator, dataInregistrare, dataStergere FROM istoricUtilizatori WHERE (idIstoric = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idUtilizator" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idUtilizator" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@dataInregistrare" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="dataInregistrare" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@dataStergere" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="dataStergere" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT idIstoric, idUtilizator, dataInregistrare, dataStergere FROM dbo.istoricUtilizatori</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[istoricUtilizatori] SET [idUtilizator] = @idUtilizator, [dataInregistrare] = @dataInregistrare, [dataStergere] = @dataStergere WHERE (([idIstoric] = @Original_idIstoric) AND ([idUtilizator] = @Original_idUtilizator) AND ([dataInregistrare] = @Original_dataInregistrare) AND ((@IsNull_dataStergere = 1 AND [dataStergere] IS NULL) OR ([dataStergere] = @Original_dataStergere)));
SELECT idIstoric, idUtilizator, dataInregistrare, dataStergere FROM istoricUtilizatori WHERE (idIstoric = @idIstoric)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idUtilizator" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idUtilizator" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@dataInregistrare" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="dataInregistrare" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@dataStergere" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="dataStergere" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idIstoric" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idIstoric" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idUtilizator" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idUtilizator" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_dataInregistrare" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="dataInregistrare" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dataStergere" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dataStergere" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_dataStergere" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="dataStergere" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="idIstoric" ColumnName="idIstoric" DataSourceName="library.dbo.istoricUtilizatori" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@idIstoric" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="idIstoric" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="idIstoric" DataSetColumn="idIstoric" />
              <Mapping SourceColumn="idUtilizator" DataSetColumn="idUtilizator" />
              <Mapping SourceColumn="dataInregistrare" DataSetColumn="dataInregistrare" />
              <Mapping SourceColumn="dataStergere" DataSetColumn="dataStergere" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="logareTableAdapter" GeneratorDataComponentClassName="logareTableAdapter" Name="logare" UserDataComponentName="logareTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="usersConnectionString (Settings)" DbObjectName="library.dbo.logare" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[logare] WHERE (([idLogare] = @Original_idLogare) AND ([idUtilizator] = @Original_idUtilizator) AND ([dataLogare] = @Original_dataLogare))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idLogare" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idLogare" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idUtilizator" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idUtilizator" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_dataLogare" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="dataLogare" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[logare] ([idUtilizator], [dataLogare]) VALUES (@idUtilizator, @dataLogare);
SELECT idLogare, idUtilizator, dataLogare FROM logare WHERE (idLogare = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idUtilizator" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idUtilizator" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@dataLogare" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="dataLogare" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT idLogare, idUtilizator, dataLogare FROM dbo.logare</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[logare] SET [idUtilizator] = @idUtilizator, [dataLogare] = @dataLogare WHERE (([idLogare] = @Original_idLogare) AND ([idUtilizator] = @Original_idUtilizator) AND ([dataLogare] = @Original_dataLogare));
SELECT idLogare, idUtilizator, dataLogare FROM logare WHERE (idLogare = @idLogare)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idUtilizator" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idUtilizator" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@dataLogare" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="dataLogare" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idLogare" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idLogare" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idUtilizator" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idUtilizator" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_dataLogare" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="dataLogare" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="idLogare" ColumnName="idLogare" DataSourceName="library.dbo.logare" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@idLogare" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="idLogare" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="idLogare" DataSetColumn="idLogare" />
              <Mapping SourceColumn="idUtilizator" DataSetColumn="idUtilizator" />
              <Mapping SourceColumn="dataLogare" DataSetColumn="dataLogare" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="penalizareTableAdapter" GeneratorDataComponentClassName="penalizareTableAdapter" Name="penalizare" UserDataComponentName="penalizareTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="usersConnectionString (Settings)" DbObjectName="library.dbo.penalizare" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[penalizare] WHERE (([idPenalizare] = @Original_idPenalizare) AND ([idUtilizator] = @Original_idUtilizator) AND ([dataPenalizare] = @Original_dataPenalizare) AND ([motiv] = @Original_motiv) AND ((@IsNull_dataPlata = 1 AND [dataPlata] IS NULL) OR ([dataPlata] = @Original_dataPlata)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idPenalizare" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idPenalizare" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idUtilizator" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idUtilizator" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_dataPenalizare" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="dataPenalizare" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_motiv" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="motiv" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dataPlata" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dataPlata" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_dataPlata" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="dataPlata" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[penalizare] ([idUtilizator], [dataPenalizare], [motiv], [dataPlata]) VALUES (@idUtilizator, @dataPenalizare, @motiv, @dataPlata);
SELECT idPenalizare, idUtilizator, dataPenalizare, motiv, dataPlata FROM penalizare WHERE (idPenalizare = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idUtilizator" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idUtilizator" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@dataPenalizare" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="dataPenalizare" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@motiv" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="motiv" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@dataPlata" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="dataPlata" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT idPenalizare, idUtilizator, dataPenalizare, motiv, dataPlata FROM dbo.penalizare</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[penalizare] SET [idUtilizator] = @idUtilizator, [dataPenalizare] = @dataPenalizare, [motiv] = @motiv, [dataPlata] = @dataPlata WHERE (([idPenalizare] = @Original_idPenalizare) AND ([idUtilizator] = @Original_idUtilizator) AND ([dataPenalizare] = @Original_dataPenalizare) AND ([motiv] = @Original_motiv) AND ((@IsNull_dataPlata = 1 AND [dataPlata] IS NULL) OR ([dataPlata] = @Original_dataPlata)));
SELECT idPenalizare, idUtilizator, dataPenalizare, motiv, dataPlata FROM penalizare WHERE (idPenalizare = @idPenalizare)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idUtilizator" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idUtilizator" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@dataPenalizare" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="dataPenalizare" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@motiv" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="motiv" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@dataPlata" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="dataPlata" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idPenalizare" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idPenalizare" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idUtilizator" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idUtilizator" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_dataPenalizare" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="dataPenalizare" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_motiv" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="motiv" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dataPlata" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dataPlata" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_dataPlata" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="dataPlata" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="idPenalizare" ColumnName="idPenalizare" DataSourceName="library.dbo.penalizare" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@idPenalizare" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="idPenalizare" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="idPenalizare" DataSetColumn="idPenalizare" />
              <Mapping SourceColumn="idUtilizator" DataSetColumn="idUtilizator" />
              <Mapping SourceColumn="dataPenalizare" DataSetColumn="dataPenalizare" />
              <Mapping SourceColumn="motiv" DataSetColumn="motiv" />
              <Mapping SourceColumn="dataPlata" DataSetColumn="dataPlata" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="stareProdusTableAdapter" GeneratorDataComponentClassName="stareProdusTableAdapter" Name="stareProdus" UserDataComponentName="stareProdusTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="usersConnectionString (Settings)" DbObjectName="library.dbo.stareProdus" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[stareProdus] WHERE (([idStareProdus] = @Original_idStareProdus) AND ([stareProdus] = @Original_stareProdus))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idStareProdus" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idStareProdus" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_stareProdus" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="stareProdus" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[stareProdus] ([stareProdus]) VALUES (@stareProdus);
SELECT idStareProdus, stareProdus FROM stareProdus WHERE (idStareProdus = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@stareProdus" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="stareProdus" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT idStareProdus, stareProdus FROM dbo.stareProdus</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[stareProdus] SET [stareProdus] = @stareProdus WHERE (([idStareProdus] = @Original_idStareProdus) AND ([stareProdus] = @Original_stareProdus));
SELECT idStareProdus, stareProdus FROM stareProdus WHERE (idStareProdus = @idStareProdus)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@stareProdus" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="stareProdus" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idStareProdus" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idStareProdus" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_stareProdus" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="stareProdus" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="idStareProdus" ColumnName="idStareProdus" DataSourceName="library.dbo.stareProdus" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@idStareProdus" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="idStareProdus" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="idStareProdus" DataSetColumn="idStareProdus" />
              <Mapping SourceColumn="stareProdus" DataSetColumn="stareProdus" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tipProdusTableAdapter" GeneratorDataComponentClassName="tipProdusTableAdapter" Name="tipProdus" UserDataComponentName="tipProdusTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="usersConnectionString (Settings)" DbObjectName="library.dbo.tipProdus" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[tipProdus] WHERE (([idTipProdus] = @Original_idTipProdus) AND ([tipProdus] = @Original_tipProdus))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idTipProdus" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idTipProdus" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_tipProdus" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tipProdus" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[tipProdus] ([tipProdus]) VALUES (@tipProdus);
SELECT idTipProdus, tipProdus FROM tipProdus WHERE (idTipProdus = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@tipProdus" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tipProdus" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT idTipProdus, tipProdus FROM dbo.tipProdus</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[tipProdus] SET [tipProdus] = @tipProdus WHERE (([idTipProdus] = @Original_idTipProdus) AND ([tipProdus] = @Original_tipProdus));
SELECT idTipProdus, tipProdus FROM tipProdus WHERE (idTipProdus = @idTipProdus)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@tipProdus" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tipProdus" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idTipProdus" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idTipProdus" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_tipProdus" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tipProdus" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="idTipProdus" ColumnName="idTipProdus" DataSourceName="library.dbo.tipProdus" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@idTipProdus" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="idTipProdus" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="idTipProdus" DataSetColumn="idTipProdus" />
              <Mapping SourceColumn="tipProdus" DataSetColumn="tipProdus" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tipUnitateOpticaTableAdapter" GeneratorDataComponentClassName="tipUnitateOpticaTableAdapter" Name="tipUnitateOptica" UserDataComponentName="tipUnitateOpticaTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="usersConnectionString (Settings)" DbObjectName="library.dbo.tipUnitateOptica" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[tipUnitateOptica] WHERE (([idTipUnitateOptica] = @Original_idTipUnitateOptica) AND ([tipUnitateOptica] = @Original_tipUnitateOptica) AND ([descriere] = @Original_descriere))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idTipUnitateOptica" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idTipUnitateOptica" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_tipUnitateOptica" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tipUnitateOptica" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_descriere" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="descriere" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[tipUnitateOptica] ([tipUnitateOptica], [descriere]) VALUES (@tipUnitateOptica, @descriere);
SELECT idTipUnitateOptica, tipUnitateOptica, descriere FROM tipUnitateOptica WHERE (idTipUnitateOptica = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@tipUnitateOptica" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tipUnitateOptica" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@descriere" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="descriere" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT idTipUnitateOptica, tipUnitateOptica, descriere FROM dbo.tipUnitateOptica</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[tipUnitateOptica] SET [tipUnitateOptica] = @tipUnitateOptica, [descriere] = @descriere WHERE (([idTipUnitateOptica] = @Original_idTipUnitateOptica) AND ([tipUnitateOptica] = @Original_tipUnitateOptica) AND ([descriere] = @Original_descriere));
SELECT idTipUnitateOptica, tipUnitateOptica, descriere FROM tipUnitateOptica WHERE (idTipUnitateOptica = @idTipUnitateOptica)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@tipUnitateOptica" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tipUnitateOptica" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@descriere" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="descriere" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idTipUnitateOptica" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idTipUnitateOptica" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_tipUnitateOptica" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tipUnitateOptica" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_descriere" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="descriere" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="idTipUnitateOptica" ColumnName="idTipUnitateOptica" DataSourceName="library.dbo.tipUnitateOptica" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@idTipUnitateOptica" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="idTipUnitateOptica" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="idTipUnitateOptica" DataSetColumn="idTipUnitateOptica" />
              <Mapping SourceColumn="tipUnitateOptica" DataSetColumn="tipUnitateOptica" />
              <Mapping SourceColumn="descriere" DataSetColumn="descriere" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tipUtilizatorTableAdapter" GeneratorDataComponentClassName="tipUtilizatorTableAdapter" Name="tipUtilizator" UserDataComponentName="tipUtilizatorTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="usersConnectionString (Settings)" DbObjectName="library.dbo.tipUtilizator" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[tipUtilizator] WHERE (([idTipUtilizator] = @Original_idTipUtilizator) AND ([tipUtilizator] = @Original_tipUtilizator))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idTipUtilizator" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idTipUtilizator" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_tipUtilizator" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tipUtilizator" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[tipUtilizator] ([tipUtilizator]) VALUES (@tipUtilizator);
SELECT idTipUtilizator, tipUtilizator FROM tipUtilizator WHERE (idTipUtilizator = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@tipUtilizator" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tipUtilizator" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT idTipUtilizator, tipUtilizator FROM dbo.tipUtilizator</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[tipUtilizator] SET [tipUtilizator] = @tipUtilizator WHERE (([idTipUtilizator] = @Original_idTipUtilizator) AND ([tipUtilizator] = @Original_tipUtilizator));
SELECT idTipUtilizator, tipUtilizator FROM tipUtilizator WHERE (idTipUtilizator = @idTipUtilizator)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@tipUtilizator" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tipUtilizator" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idTipUtilizator" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idTipUtilizator" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_tipUtilizator" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tipUtilizator" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="idTipUtilizator" ColumnName="idTipUtilizator" DataSourceName="library.dbo.tipUtilizator" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@idTipUtilizator" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="idTipUtilizator" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="idTipUtilizator" DataSetColumn="idTipUtilizator" />
              <Mapping SourceColumn="tipUtilizator" DataSetColumn="tipUtilizator" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="unitateDeBandaTableAdapter" GeneratorDataComponentClassName="unitateDeBandaTableAdapter" Name="unitateDeBanda" UserDataComponentName="unitateDeBandaTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="usersConnectionString (Settings)" DbObjectName="library.dbo.unitateDeBanda" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[unitateDeBanda] WHERE (([idUnitateDeBanda] = @Original_idUnitateDeBanda) AND ([idProdus] = @Original_idProdus) AND ([lungimeInregistrare] = @Original_lungimeInregistrare))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idUnitateDeBanda" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idUnitateDeBanda" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idProdus" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idProdus" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_lungimeInregistrare" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="lungimeInregistrare" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[unitateDeBanda] ([idProdus], [lungimeInregistrare]) VALUES (@idProdus, @lungimeInregistrare);
SELECT idUnitateDeBanda, idProdus, lungimeInregistrare FROM unitateDeBanda WHERE (idUnitateDeBanda = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idProdus" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idProdus" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@lungimeInregistrare" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="lungimeInregistrare" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT idUnitateDeBanda, idProdus, lungimeInregistrare FROM dbo.unitateDeBanda</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[unitateDeBanda] SET [idProdus] = @idProdus, [lungimeInregistrare] = @lungimeInregistrare WHERE (([idUnitateDeBanda] = @Original_idUnitateDeBanda) AND ([idProdus] = @Original_idProdus) AND ([lungimeInregistrare] = @Original_lungimeInregistrare));
SELECT idUnitateDeBanda, idProdus, lungimeInregistrare FROM unitateDeBanda WHERE (idUnitateDeBanda = @idUnitateDeBanda)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idProdus" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idProdus" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@lungimeInregistrare" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="lungimeInregistrare" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idUnitateDeBanda" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idUnitateDeBanda" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idProdus" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idProdus" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_lungimeInregistrare" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="lungimeInregistrare" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="idUnitateDeBanda" ColumnName="idUnitateDeBanda" DataSourceName="library.dbo.unitateDeBanda" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@idUnitateDeBanda" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="idUnitateDeBanda" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="idUnitateDeBanda" DataSetColumn="idUnitateDeBanda" />
              <Mapping SourceColumn="idProdus" DataSetColumn="idProdus" />
              <Mapping SourceColumn="lungimeInregistrare" DataSetColumn="lungimeInregistrare" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="unitateOpticaTableAdapter" GeneratorDataComponentClassName="unitateOpticaTableAdapter" Name="unitateOptica" UserDataComponentName="unitateOpticaTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="usersConnectionString (Settings)" DbObjectName="library.dbo.unitateOptica" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[unitateOptica] WHERE (([idUnitateOptica] = @Original_idUnitateOptica) AND ([idProdus] = @Original_idProdus) AND ([idTipUnitateOptica] = @Original_idTipUnitateOptica))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idUnitateOptica" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idUnitateOptica" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idProdus" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idProdus" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idTipUnitateOptica" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idTipUnitateOptica" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[unitateOptica] ([idProdus], [idTipUnitateOptica]) VALUES (@idProdus, @idTipUnitateOptica);
SELECT idUnitateOptica, idProdus, idTipUnitateOptica FROM unitateOptica WHERE (idUnitateOptica = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idProdus" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idProdus" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idTipUnitateOptica" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idTipUnitateOptica" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT idUnitateOptica, idProdus, idTipUnitateOptica FROM dbo.unitateOptica</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[unitateOptica] SET [idProdus] = @idProdus, [idTipUnitateOptica] = @idTipUnitateOptica WHERE (([idUnitateOptica] = @Original_idUnitateOptica) AND ([idProdus] = @Original_idProdus) AND ([idTipUnitateOptica] = @Original_idTipUnitateOptica));
SELECT idUnitateOptica, idProdus, idTipUnitateOptica FROM unitateOptica WHERE (idUnitateOptica = @idUnitateOptica)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idProdus" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idProdus" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idTipUnitateOptica" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idTipUnitateOptica" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idUnitateOptica" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idUnitateOptica" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idProdus" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idProdus" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idTipUnitateOptica" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idTipUnitateOptica" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="idUnitateOptica" ColumnName="idUnitateOptica" DataSourceName="library.dbo.unitateOptica" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@idUnitateOptica" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="idUnitateOptica" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="idUnitateOptica" DataSetColumn="idUnitateOptica" />
              <Mapping SourceColumn="idProdus" DataSetColumn="idProdus" />
              <Mapping SourceColumn="idTipUnitateOptica" DataSetColumn="idTipUnitateOptica" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="utilizatorTableAdapter" GeneratorDataComponentClassName="utilizatorTableAdapter" Name="utilizator" UserDataComponentName="utilizatorTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="usersConnectionString (Settings)" DbObjectName="library.dbo.utilizator" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[utilizator] WHERE (([idUtilizator] = @Original_idUtilizator) AND ([nume] = @Original_nume) AND ([prenume] = @Original_prenume) AND ([cnp] = @Original_cnp) AND ([email] = @Original_email) AND ([username] = @Original_username) AND ([password] = @Original_password) AND ([penalizat] = @Original_penalizat) AND ([idTipUtilizator] = @Original_idTipUtilizator) AND ([activ] = @Original_activ))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idUtilizator" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idUtilizator" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_nume" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nume" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_prenume" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="prenume" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cnp" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cnp" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_email" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="email" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_username" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="username" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_password" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="password" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@Original_penalizat" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="penalizat" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idTipUtilizator" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idTipUtilizator" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@Original_activ" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="activ" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[utilizator] ([nume], [prenume], [cnp], [email], [username], [password], [penalizat], [idTipUtilizator], [activ]) VALUES (@nume, @prenume, @cnp, @email, @username, @password, @penalizat, @idTipUtilizator, @activ);
SELECT idUtilizator, nume, prenume, cnp, email, username, password, penalizat, idTipUtilizator, activ FROM utilizator WHERE (idUtilizator = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@nume" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nume" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@prenume" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="prenume" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cnp" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cnp" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@email" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="email" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@username" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="username" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@password" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="password" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@penalizat" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="penalizat" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idTipUtilizator" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idTipUtilizator" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@activ" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="activ" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT idUtilizator, nume, prenume, cnp, email, username, password, penalizat, idTipUtilizator, activ FROM dbo.utilizator</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[utilizator] SET [nume] = @nume, [prenume] = @prenume, [cnp] = @cnp, [email] = @email, [username] = @username, [password] = @password, [penalizat] = @penalizat, [idTipUtilizator] = @idTipUtilizator, [activ] = @activ WHERE (([idUtilizator] = @Original_idUtilizator) AND ([nume] = @Original_nume) AND ([prenume] = @Original_prenume) AND ([cnp] = @Original_cnp) AND ([email] = @Original_email) AND ([username] = @Original_username) AND ([password] = @Original_password) AND ([penalizat] = @Original_penalizat) AND ([idTipUtilizator] = @Original_idTipUtilizator) AND ([activ] = @Original_activ));
SELECT idUtilizator, nume, prenume, cnp, email, username, password, penalizat, idTipUtilizator, activ FROM utilizator WHERE (idUtilizator = @idUtilizator)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@nume" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nume" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@prenume" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="prenume" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cnp" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cnp" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@email" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="email" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@username" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="username" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@password" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="password" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@penalizat" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="penalizat" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idTipUtilizator" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idTipUtilizator" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@activ" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="activ" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idUtilizator" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idUtilizator" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_nume" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nume" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_prenume" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="prenume" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cnp" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cnp" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_email" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="email" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_username" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="username" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_password" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="password" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@Original_penalizat" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="penalizat" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idTipUtilizator" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idTipUtilizator" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@Original_activ" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="activ" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="idUtilizator" ColumnName="idUtilizator" DataSourceName="library.dbo.utilizator" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@idUtilizator" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="idUtilizator" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="idUtilizator" DataSetColumn="idUtilizator" />
              <Mapping SourceColumn="nume" DataSetColumn="nume" />
              <Mapping SourceColumn="prenume" DataSetColumn="prenume" />
              <Mapping SourceColumn="cnp" DataSetColumn="cnp" />
              <Mapping SourceColumn="email" DataSetColumn="email" />
              <Mapping SourceColumn="username" DataSetColumn="username" />
              <Mapping SourceColumn="password" DataSetColumn="password" />
              <Mapping SourceColumn="penalizat" DataSetColumn="penalizat" />
              <Mapping SourceColumn="idTipUtilizator" DataSetColumn="idTipUtilizator" />
              <Mapping SourceColumn="activ" DataSetColumn="activ" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="AllFieldsLibrary" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_UserDSName="AllFieldsLibrary" msprop:Generator_DataSetName="AllFieldsLibrary" msprop:EnableTableAdapterManager="True">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="autor" msprop:Generator_UserTableName="autor" msprop:Generator_RowDeletedName="autorRowDeleted" msprop:Generator_RowChangedName="autorRowChanged" msprop:Generator_RowClassName="autorRow" msprop:Generator_RowChangingName="autorRowChanging" msprop:Generator_RowEvArgName="autorRowChangeEvent" msprop:Generator_RowEvHandlerName="autorRowChangeEventHandler" msprop:Generator_TableClassName="autorDataTable" msprop:Generator_TableVarName="tableautor" msprop:Generator_RowDeletingName="autorRowDeleting" msprop:Generator_TablePropName="autor">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="idAutor" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="idAutor" msprop:Generator_ColumnVarNameInTable="columnidAutor" msprop:Generator_ColumnPropNameInRow="idAutor" msprop:Generator_ColumnPropNameInTable="idAutorColumn" type="xs:int" />
              <xs:element name="numeAutor" msprop:Generator_UserColumnName="numeAutor" msprop:Generator_ColumnVarNameInTable="columnnumeAutor" msprop:Generator_ColumnPropNameInRow="numeAutor" msprop:Generator_ColumnPropNameInTable="numeAutorColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="prenumeAutor" msprop:Generator_UserColumnName="prenumeAutor" msprop:Generator_ColumnVarNameInTable="columnprenumeAutor" msprop:Generator_ColumnPropNameInRow="prenumeAutor" msprop:Generator_ColumnPropNameInTable="prenumeAutorColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="autorProdus" msprop:Generator_UserTableName="autorProdus" msprop:Generator_RowDeletedName="autorProdusRowDeleted" msprop:Generator_RowChangedName="autorProdusRowChanged" msprop:Generator_RowClassName="autorProdusRow" msprop:Generator_RowChangingName="autorProdusRowChanging" msprop:Generator_RowEvArgName="autorProdusRowChangeEvent" msprop:Generator_RowEvHandlerName="autorProdusRowChangeEventHandler" msprop:Generator_TableClassName="autorProdusDataTable" msprop:Generator_TableVarName="tableautorProdus" msprop:Generator_RowDeletingName="autorProdusRowDeleting" msprop:Generator_TablePropName="autorProdus">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="idProdus" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="idProdus" msprop:Generator_ColumnVarNameInTable="columnidProdus" msprop:Generator_ColumnPropNameInRow="idProdus" msprop:Generator_ColumnPropNameInTable="idProdusColumn" type="xs:int" />
              <xs:element name="idAutor" msprop:Generator_UserColumnName="idAutor" msprop:Generator_ColumnVarNameInTable="columnidAutor" msprop:Generator_ColumnPropNameInRow="idAutor" msprop:Generator_ColumnPropNameInTable="idAutorColumn" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="carteRevista" msprop:Generator_UserTableName="carteRevista" msprop:Generator_RowDeletedName="carteRevistaRowDeleted" msprop:Generator_RowChangedName="carteRevistaRowChanged" msprop:Generator_RowClassName="carteRevistaRow" msprop:Generator_RowChangingName="carteRevistaRowChanging" msprop:Generator_RowEvArgName="carteRevistaRowChangeEvent" msprop:Generator_RowEvHandlerName="carteRevistaRowChangeEventHandler" msprop:Generator_TableClassName="carteRevistaDataTable" msprop:Generator_TableVarName="tablecarteRevista" msprop:Generator_RowDeletingName="carteRevistaRowDeleting" msprop:Generator_TablePropName="carteRevista">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="idCarteRevista" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="idCarteRevista" msprop:Generator_ColumnVarNameInTable="columnidCarteRevista" msprop:Generator_ColumnPropNameInRow="idCarteRevista" msprop:Generator_ColumnPropNameInTable="idCarteRevistaColumn" type="xs:int" />
              <xs:element name="idProdus" msprop:Generator_UserColumnName="idProdus" msprop:Generator_ColumnVarNameInTable="columnidProdus" msprop:Generator_ColumnPropNameInRow="idProdus" msprop:Generator_ColumnPropNameInTable="idProdusColumn" type="xs:int" />
              <xs:element name="nrPagini" msprop:Generator_UserColumnName="nrPagini" msprop:Generator_ColumnVarNameInTable="columnnrPagini" msprop:Generator_ColumnPropNameInRow="nrPagini" msprop:Generator_ColumnPropNameInTable="nrPaginiColumn" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="detaliiProdus" msprop:Generator_UserTableName="detaliiProdus" msprop:Generator_RowDeletedName="detaliiProdusRowDeleted" msprop:Generator_RowChangedName="detaliiProdusRowChanged" msprop:Generator_RowClassName="detaliiProdusRow" msprop:Generator_RowChangingName="detaliiProdusRowChanging" msprop:Generator_RowEvArgName="detaliiProdusRowChangeEvent" msprop:Generator_RowEvHandlerName="detaliiProdusRowChangeEventHandler" msprop:Generator_TableClassName="detaliiProdusDataTable" msprop:Generator_TableVarName="tabledetaliiProdus" msprop:Generator_RowDeletingName="detaliiProdusRowDeleting" msprop:Generator_TablePropName="detaliiProdus">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="idProdus" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="idProdus" msprop:Generator_ColumnVarNameInTable="columnidProdus" msprop:Generator_ColumnPropNameInRow="idProdus" msprop:Generator_ColumnPropNameInTable="idProdusColumn" type="xs:int" />
              <xs:element name="titlu" msprop:Generator_UserColumnName="titlu" msprop:Generator_ColumnVarNameInTable="columntitlu" msprop:Generator_ColumnPropNameInRow="titlu" msprop:Generator_ColumnPropNameInTable="titluColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="producator" msprop:Generator_UserColumnName="producator" msprop:Generator_ColumnVarNameInTable="columnproducator" msprop:Generator_ColumnPropNameInRow="producator" msprop:Generator_ColumnPropNameInTable="producatorColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="idTipProdus" msprop:Generator_UserColumnName="idTipProdus" msprop:Generator_ColumnVarNameInTable="columnidTipProdus" msprop:Generator_ColumnPropNameInRow="idTipProdus" msprop:Generator_ColumnPropNameInTable="idTipProdusColumn" type="xs:int" />
              <xs:element name="idDomeniu" msprop:Generator_UserColumnName="idDomeniu" msprop:Generator_ColumnVarNameInTable="columnidDomeniu" msprop:Generator_ColumnPropNameInRow="idDomeniu" msprop:Generator_ColumnPropNameInTable="idDomeniuColumn" type="xs:int" />
              <xs:element name="anAparitie" msprop:Generator_UserColumnName="anAparitie" msprop:Generator_ColumnVarNameInTable="columnanAparitie" msprop:Generator_ColumnPropNameInRow="anAparitie" msprop:Generator_ColumnPropNameInTable="anAparitieColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="4" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="descriere" msprop:Generator_UserColumnName="descriere" msprop:Generator_ColumnVarNameInTable="columndescriere" msprop:Generator_ColumnPropNameInRow="descriere" msprop:Generator_ColumnPropNameInTable="descriereColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="imagine" msprop:Generator_UserColumnName="imagine" msprop:Generator_ColumnVarNameInTable="columnimagine" msprop:Generator_ColumnPropNameInRow="imagine" msprop:Generator_ColumnPropNameInTable="imagineColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="autor" msprop:Generator_UserColumnName="autor" msprop:Generator_ColumnPropNameInRow="autor" msprop:Generator_ColumnVarNameInTable="columnautor" msprop:Generator_ColumnPropNameInTable="autorColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="domeniu" msprop:Generator_UserTableName="domeniu" msprop:Generator_RowDeletedName="domeniuRowDeleted" msprop:Generator_RowChangedName="domeniuRowChanged" msprop:Generator_RowClassName="domeniuRow" msprop:Generator_RowChangingName="domeniuRowChanging" msprop:Generator_RowEvArgName="domeniuRowChangeEvent" msprop:Generator_RowEvHandlerName="domeniuRowChangeEventHandler" msprop:Generator_TableClassName="domeniuDataTable" msprop:Generator_TableVarName="tabledomeniu" msprop:Generator_RowDeletingName="domeniuRowDeleting" msprop:Generator_TablePropName="domeniu">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="idDomeniu" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="idDomeniu" msprop:Generator_ColumnVarNameInTable="columnidDomeniu" msprop:Generator_ColumnPropNameInRow="idDomeniu" msprop:Generator_ColumnPropNameInTable="idDomeniuColumn" type="xs:int" />
              <xs:element name="numeDomeniu" msprop:Generator_UserColumnName="numeDomeniu" msprop:Generator_ColumnVarNameInTable="columnnumeDomeniu" msprop:Generator_ColumnPropNameInRow="numeDomeniu" msprop:Generator_ColumnPropNameInTable="numeDomeniuColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="exemplar" msprop:Generator_UserTableName="exemplar" msprop:Generator_RowDeletedName="exemplarRowDeleted" msprop:Generator_RowChangedName="exemplarRowChanged" msprop:Generator_RowClassName="exemplarRow" msprop:Generator_RowChangingName="exemplarRowChanging" msprop:Generator_RowEvArgName="exemplarRowChangeEvent" msprop:Generator_RowEvHandlerName="exemplarRowChangeEventHandler" msprop:Generator_TableClassName="exemplarDataTable" msprop:Generator_TableVarName="tableexemplar" msprop:Generator_RowDeletingName="exemplarRowDeleting" msprop:Generator_TablePropName="exemplar">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="idExemplar" msprop:Generator_UserColumnName="idExemplar" msprop:Generator_ColumnVarNameInTable="columnidExemplar" msprop:Generator_ColumnPropNameInRow="idExemplar" msprop:Generator_ColumnPropNameInTable="idExemplarColumn" type="xs:int" />
              <xs:element name="idProdus" msprop:Generator_UserColumnName="idProdus" msprop:Generator_ColumnVarNameInTable="columnidProdus" msprop:Generator_ColumnPropNameInRow="idProdus" msprop:Generator_ColumnPropNameInTable="idProdusColumn" type="xs:int" />
              <xs:element name="idStareProdus" msprop:Generator_UserColumnName="idStareProdus" msprop:Generator_ColumnVarNameInTable="columnidStareProdus" msprop:Generator_ColumnPropNameInRow="idStareProdus" msprop:Generator_ColumnPropNameInTable="idStareProdusColumn" type="xs:int" />
              <xs:element name="ptImprumutat" msprop:Generator_UserColumnName="ptImprumutat" msprop:Generator_ColumnVarNameInTable="columnptImprumutat" msprop:Generator_ColumnPropNameInRow="ptImprumutat" msprop:Generator_ColumnPropNameInTable="ptImprumutatColumn" type="xs:boolean" />
              <xs:element name="pret" msprop:Generator_UserColumnName="pret" msprop:Generator_ColumnVarNameInTable="columnpret" msprop:Generator_ColumnPropNameInRow="pret" msprop:Generator_ColumnPropNameInTable="pretColumn" type="xs:double" />
              <xs:element name="inStoc" msprop:Generator_UserColumnName="inStoc" msprop:Generator_ColumnVarNameInTable="columninStoc" msprop:Generator_ColumnPropNameInRow="inStoc" msprop:Generator_ColumnPropNameInTable="inStocColumn" type="xs:boolean" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="istoricUtilizatori" msprop:Generator_UserTableName="istoricUtilizatori" msprop:Generator_RowDeletedName="istoricUtilizatoriRowDeleted" msprop:Generator_RowChangedName="istoricUtilizatoriRowChanged" msprop:Generator_RowClassName="istoricUtilizatoriRow" msprop:Generator_RowChangingName="istoricUtilizatoriRowChanging" msprop:Generator_RowEvArgName="istoricUtilizatoriRowChangeEvent" msprop:Generator_RowEvHandlerName="istoricUtilizatoriRowChangeEventHandler" msprop:Generator_TableClassName="istoricUtilizatoriDataTable" msprop:Generator_TableVarName="tableistoricUtilizatori" msprop:Generator_RowDeletingName="istoricUtilizatoriRowDeleting" msprop:Generator_TablePropName="istoricUtilizatori">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="idIstoric" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="idIstoric" msprop:Generator_ColumnVarNameInTable="columnidIstoric" msprop:Generator_ColumnPropNameInRow="idIstoric" msprop:Generator_ColumnPropNameInTable="idIstoricColumn" type="xs:int" />
              <xs:element name="idUtilizator" msprop:Generator_UserColumnName="idUtilizator" msprop:Generator_ColumnVarNameInTable="columnidUtilizator" msprop:Generator_ColumnPropNameInRow="idUtilizator" msprop:Generator_ColumnPropNameInTable="idUtilizatorColumn" type="xs:int" />
              <xs:element name="dataInregistrare" msprop:Generator_UserColumnName="dataInregistrare" msprop:Generator_ColumnVarNameInTable="columndataInregistrare" msprop:Generator_ColumnPropNameInRow="dataInregistrare" msprop:Generator_ColumnPropNameInTable="dataInregistrareColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="dataStergere" msprop:Generator_UserColumnName="dataStergere" msprop:Generator_ColumnVarNameInTable="columndataStergere" msprop:Generator_ColumnPropNameInRow="dataStergere" msprop:Generator_ColumnPropNameInTable="dataStergereColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="logare" msprop:Generator_UserTableName="logare" msprop:Generator_RowDeletedName="logareRowDeleted" msprop:Generator_RowChangedName="logareRowChanged" msprop:Generator_RowClassName="logareRow" msprop:Generator_RowChangingName="logareRowChanging" msprop:Generator_RowEvArgName="logareRowChangeEvent" msprop:Generator_RowEvHandlerName="logareRowChangeEventHandler" msprop:Generator_TableClassName="logareDataTable" msprop:Generator_TableVarName="tablelogare" msprop:Generator_RowDeletingName="logareRowDeleting" msprop:Generator_TablePropName="logare">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="idLogare" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="idLogare" msprop:Generator_ColumnVarNameInTable="columnidLogare" msprop:Generator_ColumnPropNameInRow="idLogare" msprop:Generator_ColumnPropNameInTable="idLogareColumn" type="xs:int" />
              <xs:element name="idUtilizator" msprop:Generator_UserColumnName="idUtilizator" msprop:Generator_ColumnVarNameInTable="columnidUtilizator" msprop:Generator_ColumnPropNameInRow="idUtilizator" msprop:Generator_ColumnPropNameInTable="idUtilizatorColumn" type="xs:int" />
              <xs:element name="dataLogare" msprop:Generator_UserColumnName="dataLogare" msprop:Generator_ColumnVarNameInTable="columndataLogare" msprop:Generator_ColumnPropNameInRow="dataLogare" msprop:Generator_ColumnPropNameInTable="dataLogareColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="penalizare" msprop:Generator_UserTableName="penalizare" msprop:Generator_RowDeletedName="penalizareRowDeleted" msprop:Generator_RowChangedName="penalizareRowChanged" msprop:Generator_RowClassName="penalizareRow" msprop:Generator_RowChangingName="penalizareRowChanging" msprop:Generator_RowEvArgName="penalizareRowChangeEvent" msprop:Generator_RowEvHandlerName="penalizareRowChangeEventHandler" msprop:Generator_TableClassName="penalizareDataTable" msprop:Generator_TableVarName="tablepenalizare" msprop:Generator_RowDeletingName="penalizareRowDeleting" msprop:Generator_TablePropName="penalizare">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="idPenalizare" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="idPenalizare" msprop:Generator_ColumnVarNameInTable="columnidPenalizare" msprop:Generator_ColumnPropNameInRow="idPenalizare" msprop:Generator_ColumnPropNameInTable="idPenalizareColumn" type="xs:int" />
              <xs:element name="idUtilizator" msprop:Generator_UserColumnName="idUtilizator" msprop:Generator_ColumnVarNameInTable="columnidUtilizator" msprop:Generator_ColumnPropNameInRow="idUtilizator" msprop:Generator_ColumnPropNameInTable="idUtilizatorColumn" type="xs:int" />
              <xs:element name="dataPenalizare" msprop:Generator_UserColumnName="dataPenalizare" msprop:Generator_ColumnVarNameInTable="columndataPenalizare" msprop:Generator_ColumnPropNameInRow="dataPenalizare" msprop:Generator_ColumnPropNameInTable="dataPenalizareColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="motiv" msprop:Generator_UserColumnName="motiv" msprop:Generator_ColumnVarNameInTable="columnmotiv" msprop:Generator_ColumnPropNameInRow="motiv" msprop:Generator_ColumnPropNameInTable="motivColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="256" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="dataPlata" msprop:Generator_UserColumnName="dataPlata" msprop:Generator_ColumnVarNameInTable="columndataPlata" msprop:Generator_ColumnPropNameInRow="dataPlata" msprop:Generator_ColumnPropNameInTable="dataPlataColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="stareProdus" msprop:Generator_UserTableName="stareProdus" msprop:Generator_RowDeletedName="stareProdusRowDeleted" msprop:Generator_RowChangedName="stareProdusRowChanged" msprop:Generator_RowClassName="stareProdusRow" msprop:Generator_RowChangingName="stareProdusRowChanging" msprop:Generator_RowEvArgName="stareProdusRowChangeEvent" msprop:Generator_RowEvHandlerName="stareProdusRowChangeEventHandler" msprop:Generator_TableClassName="stareProdusDataTable" msprop:Generator_TableVarName="tablestareProdus" msprop:Generator_RowDeletingName="stareProdusRowDeleting" msprop:Generator_TablePropName="stareProdus">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="idStareProdus" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="idStareProdus" msprop:Generator_ColumnVarNameInTable="columnidStareProdus" msprop:Generator_ColumnPropNameInRow="idStareProdus" msprop:Generator_ColumnPropNameInTable="idStareProdusColumn" type="xs:int" />
              <xs:element name="stareProdus" msprop:Generator_UserColumnName="stareProdus" msprop:Generator_ColumnVarNameInTable="columnstareProdus" msprop:Generator_ColumnPropNameInRow="stareProdus" msprop:Generator_ColumnPropNameInTable="stareProdusColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="tipProdus" msprop:Generator_UserTableName="tipProdus" msprop:Generator_RowDeletedName="tipProdusRowDeleted" msprop:Generator_RowChangedName="tipProdusRowChanged" msprop:Generator_RowClassName="tipProdusRow" msprop:Generator_RowChangingName="tipProdusRowChanging" msprop:Generator_RowEvArgName="tipProdusRowChangeEvent" msprop:Generator_RowEvHandlerName="tipProdusRowChangeEventHandler" msprop:Generator_TableClassName="tipProdusDataTable" msprop:Generator_TableVarName="tabletipProdus" msprop:Generator_RowDeletingName="tipProdusRowDeleting" msprop:Generator_TablePropName="tipProdus">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="idTipProdus" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="idTipProdus" msprop:Generator_ColumnVarNameInTable="columnidTipProdus" msprop:Generator_ColumnPropNameInRow="idTipProdus" msprop:Generator_ColumnPropNameInTable="idTipProdusColumn" type="xs:int" />
              <xs:element name="tipProdus" msprop:Generator_UserColumnName="tipProdus" msprop:Generator_ColumnVarNameInTable="columntipProdus" msprop:Generator_ColumnPropNameInRow="tipProdus" msprop:Generator_ColumnPropNameInTable="tipProdusColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="tipUnitateOptica" msprop:Generator_UserTableName="tipUnitateOptica" msprop:Generator_RowDeletedName="tipUnitateOpticaRowDeleted" msprop:Generator_RowChangedName="tipUnitateOpticaRowChanged" msprop:Generator_RowClassName="tipUnitateOpticaRow" msprop:Generator_RowChangingName="tipUnitateOpticaRowChanging" msprop:Generator_RowEvArgName="tipUnitateOpticaRowChangeEvent" msprop:Generator_RowEvHandlerName="tipUnitateOpticaRowChangeEventHandler" msprop:Generator_TableClassName="tipUnitateOpticaDataTable" msprop:Generator_TableVarName="tabletipUnitateOptica" msprop:Generator_RowDeletingName="tipUnitateOpticaRowDeleting" msprop:Generator_TablePropName="tipUnitateOptica">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="idTipUnitateOptica" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="idTipUnitateOptica" msprop:Generator_ColumnVarNameInTable="columnidTipUnitateOptica" msprop:Generator_ColumnPropNameInRow="idTipUnitateOptica" msprop:Generator_ColumnPropNameInTable="idTipUnitateOpticaColumn" type="xs:int" />
              <xs:element name="tipUnitateOptica" msprop:Generator_UserColumnName="tipUnitateOptica" msprop:Generator_ColumnVarNameInTable="columntipUnitateOptica" msprop:Generator_ColumnPropNameInRow="tipUnitateOptica" msprop:Generator_ColumnPropNameInTable="tipUnitateOpticaColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="descriere" msprop:Generator_UserColumnName="descriere" msprop:Generator_ColumnVarNameInTable="columndescriere" msprop:Generator_ColumnPropNameInRow="descriere" msprop:Generator_ColumnPropNameInTable="descriereColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="256" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="tipUtilizator" msprop:Generator_UserTableName="tipUtilizator" msprop:Generator_RowDeletedName="tipUtilizatorRowDeleted" msprop:Generator_RowChangedName="tipUtilizatorRowChanged" msprop:Generator_RowClassName="tipUtilizatorRow" msprop:Generator_RowChangingName="tipUtilizatorRowChanging" msprop:Generator_RowEvArgName="tipUtilizatorRowChangeEvent" msprop:Generator_RowEvHandlerName="tipUtilizatorRowChangeEventHandler" msprop:Generator_TableClassName="tipUtilizatorDataTable" msprop:Generator_TableVarName="tabletipUtilizator" msprop:Generator_RowDeletingName="tipUtilizatorRowDeleting" msprop:Generator_TablePropName="tipUtilizator">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="idTipUtilizator" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="idTipUtilizator" msprop:Generator_ColumnVarNameInTable="columnidTipUtilizator" msprop:Generator_ColumnPropNameInRow="idTipUtilizator" msprop:Generator_ColumnPropNameInTable="idTipUtilizatorColumn" type="xs:int" />
              <xs:element name="tipUtilizator" msprop:Generator_UserColumnName="tipUtilizator" msprop:Generator_ColumnVarNameInTable="columntipUtilizator" msprop:Generator_ColumnPropNameInRow="tipUtilizator" msprop:Generator_ColumnPropNameInTable="tipUtilizatorColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="unitateDeBanda" msprop:Generator_UserTableName="unitateDeBanda" msprop:Generator_RowDeletedName="unitateDeBandaRowDeleted" msprop:Generator_RowChangedName="unitateDeBandaRowChanged" msprop:Generator_RowClassName="unitateDeBandaRow" msprop:Generator_RowChangingName="unitateDeBandaRowChanging" msprop:Generator_RowEvArgName="unitateDeBandaRowChangeEvent" msprop:Generator_RowEvHandlerName="unitateDeBandaRowChangeEventHandler" msprop:Generator_TableClassName="unitateDeBandaDataTable" msprop:Generator_TableVarName="tableunitateDeBanda" msprop:Generator_RowDeletingName="unitateDeBandaRowDeleting" msprop:Generator_TablePropName="unitateDeBanda">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="idUnitateDeBanda" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="idUnitateDeBanda" msprop:Generator_ColumnVarNameInTable="columnidUnitateDeBanda" msprop:Generator_ColumnPropNameInRow="idUnitateDeBanda" msprop:Generator_ColumnPropNameInTable="idUnitateDeBandaColumn" type="xs:int" />
              <xs:element name="idProdus" msprop:Generator_UserColumnName="idProdus" msprop:Generator_ColumnVarNameInTable="columnidProdus" msprop:Generator_ColumnPropNameInRow="idProdus" msprop:Generator_ColumnPropNameInTable="idProdusColumn" type="xs:int" />
              <xs:element name="lungimeInregistrare" msprop:Generator_UserColumnName="lungimeInregistrare" msprop:Generator_ColumnVarNameInTable="columnlungimeInregistrare" msprop:Generator_ColumnPropNameInRow="lungimeInregistrare" msprop:Generator_ColumnPropNameInTable="lungimeInregistrareColumn" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="unitateOptica" msprop:Generator_UserTableName="unitateOptica" msprop:Generator_RowDeletedName="unitateOpticaRowDeleted" msprop:Generator_RowChangedName="unitateOpticaRowChanged" msprop:Generator_RowClassName="unitateOpticaRow" msprop:Generator_RowChangingName="unitateOpticaRowChanging" msprop:Generator_RowEvArgName="unitateOpticaRowChangeEvent" msprop:Generator_RowEvHandlerName="unitateOpticaRowChangeEventHandler" msprop:Generator_TableClassName="unitateOpticaDataTable" msprop:Generator_TableVarName="tableunitateOptica" msprop:Generator_RowDeletingName="unitateOpticaRowDeleting" msprop:Generator_TablePropName="unitateOptica">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="idUnitateOptica" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="idUnitateOptica" msprop:Generator_ColumnVarNameInTable="columnidUnitateOptica" msprop:Generator_ColumnPropNameInRow="idUnitateOptica" msprop:Generator_ColumnPropNameInTable="idUnitateOpticaColumn" type="xs:int" />
              <xs:element name="idProdus" msprop:Generator_UserColumnName="idProdus" msprop:Generator_ColumnVarNameInTable="columnidProdus" msprop:Generator_ColumnPropNameInRow="idProdus" msprop:Generator_ColumnPropNameInTable="idProdusColumn" type="xs:int" />
              <xs:element name="idTipUnitateOptica" msprop:Generator_UserColumnName="idTipUnitateOptica" msprop:Generator_ColumnVarNameInTable="columnidTipUnitateOptica" msprop:Generator_ColumnPropNameInRow="idTipUnitateOptica" msprop:Generator_ColumnPropNameInTable="idTipUnitateOpticaColumn" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="utilizator" msprop:Generator_UserTableName="utilizator" msprop:Generator_RowDeletedName="utilizatorRowDeleted" msprop:Generator_RowChangedName="utilizatorRowChanged" msprop:Generator_RowClassName="utilizatorRow" msprop:Generator_RowChangingName="utilizatorRowChanging" msprop:Generator_RowEvArgName="utilizatorRowChangeEvent" msprop:Generator_RowEvHandlerName="utilizatorRowChangeEventHandler" msprop:Generator_TableClassName="utilizatorDataTable" msprop:Generator_TableVarName="tableutilizator" msprop:Generator_RowDeletingName="utilizatorRowDeleting" msprop:Generator_TablePropName="utilizator">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="idUtilizator" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="idUtilizator" msprop:Generator_ColumnVarNameInTable="columnidUtilizator" msprop:Generator_ColumnPropNameInRow="idUtilizator" msprop:Generator_ColumnPropNameInTable="idUtilizatorColumn" type="xs:int" />
              <xs:element name="nume" msprop:Generator_UserColumnName="nume" msprop:Generator_ColumnVarNameInTable="columnnume" msprop:Generator_ColumnPropNameInRow="nume" msprop:Generator_ColumnPropNameInTable="numeColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="prenume" msprop:Generator_UserColumnName="prenume" msprop:Generator_ColumnVarNameInTable="columnprenume" msprop:Generator_ColumnPropNameInRow="prenume" msprop:Generator_ColumnPropNameInTable="prenumeColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cnp" msprop:Generator_UserColumnName="cnp" msprop:Generator_ColumnVarNameInTable="columncnp" msprop:Generator_ColumnPropNameInRow="cnp" msprop:Generator_ColumnPropNameInTable="cnpColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="email" msprop:Generator_UserColumnName="email" msprop:Generator_ColumnVarNameInTable="columnemail" msprop:Generator_ColumnPropNameInRow="email" msprop:Generator_ColumnPropNameInTable="emailColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="username" msprop:Generator_UserColumnName="username" msprop:Generator_ColumnVarNameInTable="columnusername" msprop:Generator_ColumnPropNameInRow="username" msprop:Generator_ColumnPropNameInTable="usernameColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="password" msprop:Generator_UserColumnName="password" msprop:Generator_ColumnVarNameInTable="columnpassword" msprop:Generator_ColumnPropNameInRow="password" msprop:Generator_ColumnPropNameInTable="passwordColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="256" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="penalizat" msprop:Generator_UserColumnName="penalizat" msprop:Generator_ColumnVarNameInTable="columnpenalizat" msprop:Generator_ColumnPropNameInRow="penalizat" msprop:Generator_ColumnPropNameInTable="penalizatColumn" type="xs:unsignedByte" />
              <xs:element name="idTipUtilizator" msprop:Generator_UserColumnName="idTipUtilizator" msprop:Generator_ColumnVarNameInTable="columnidTipUtilizator" msprop:Generator_ColumnPropNameInRow="idTipUtilizator" msprop:Generator_ColumnPropNameInTable="idTipUtilizatorColumn" type="xs:int" />
              <xs:element name="activ" msprop:Generator_UserColumnName="activ" msprop:Generator_ColumnVarNameInTable="columnactiv" msprop:Generator_ColumnPropNameInRow="activ" msprop:Generator_ColumnPropNameInTable="activColumn" type="xs:unsignedByte" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:autor" />
      <xs:field xpath="mstns:idAutor" />
    </xs:unique>
    <xs:unique name="carteRevista_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:carteRevista" />
      <xs:field xpath="mstns:idCarteRevista" />
    </xs:unique>
    <xs:unique name="detaliiProdus_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:detaliiProdus" />
      <xs:field xpath="mstns:idProdus" />
    </xs:unique>
    <xs:unique name="domeniu_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:domeniu" />
      <xs:field xpath="mstns:idDomeniu" />
    </xs:unique>
    <xs:unique name="exemplar_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:exemplar" />
      <xs:field xpath="mstns:idExemplar" />
    </xs:unique>
    <xs:unique name="istoricUtilizatori_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:istoricUtilizatori" />
      <xs:field xpath="mstns:idIstoric" />
    </xs:unique>
    <xs:unique name="logare_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:logare" />
      <xs:field xpath="mstns:idLogare" />
    </xs:unique>
    <xs:unique name="penalizare_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:penalizare" />
      <xs:field xpath="mstns:idPenalizare" />
    </xs:unique>
    <xs:unique name="stareProdus_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:stareProdus" />
      <xs:field xpath="mstns:idStareProdus" />
    </xs:unique>
    <xs:unique name="tipProdus_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:tipProdus" />
      <xs:field xpath="mstns:idTipProdus" />
    </xs:unique>
    <xs:unique name="tipUnitateOptica_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:tipUnitateOptica" />
      <xs:field xpath="mstns:idTipUnitateOptica" />
    </xs:unique>
    <xs:unique name="tipUtilizator_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:tipUtilizator" />
      <xs:field xpath="mstns:idTipUtilizator" />
    </xs:unique>
    <xs:unique name="unitateDeBanda_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:unitateDeBanda" />
      <xs:field xpath="mstns:idUnitateDeBanda" />
    </xs:unique>
    <xs:unique name="unitateOptica_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:unitateOptica" />
      <xs:field xpath="mstns:idUnitateOptica" />
    </xs:unique>
    <xs:unique name="utilizator_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:utilizator" />
      <xs:field xpath="mstns:idUtilizator" />
    </xs:unique>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="FK_autorProdus_autor" msdata:parent="autor" msdata:child="autorProdus" msdata:parentkey="idAutor" msdata:childkey="idProdus" msprop:Generator_UserRelationName="FK_autorProdus_autor" msprop:Generator_RelationVarName="relationFK_autorProdus_autor" msprop:Generator_UserChildTable="autorProdus" msprop:Generator_UserParentTable="autor" msprop:Generator_ParentPropName="autorRow" msprop:Generator_ChildPropName="GetautorProdusRows" />
      <msdata:Relationship name="FK_autorProdus_detaliiProdus" msdata:parent="detaliiProdus" msdata:child="autorProdus" msdata:parentkey="idProdus" msdata:childkey="idProdus" msprop:Generator_UserRelationName="FK_autorProdus_detaliiProdus" msprop:Generator_RelationVarName="relationFK_autorProdus_detaliiProdus" msprop:Generator_UserChildTable="autorProdus" msprop:Generator_UserParentTable="detaliiProdus" msprop:Generator_ParentPropName="detaliiProdusRow" msprop:Generator_ChildPropName="GetautorProdusRows" />
      <msdata:Relationship name="FK_carteRevista_detaliiProdus" msdata:parent="detaliiProdus" msdata:child="carteRevista" msdata:parentkey="idProdus" msdata:childkey="idProdus" msprop:Generator_UserRelationName="FK_carteRevista_detaliiProdus" msprop:Generator_RelationVarName="relationFK_carteRevista_detaliiProdus" msprop:Generator_UserChildTable="carteRevista" msprop:Generator_UserParentTable="detaliiProdus" msprop:Generator_ParentPropName="detaliiProdusRow" msprop:Generator_ChildPropName="GetcarteRevistaRows" />
      <msdata:Relationship name="FK_detaliiProdus_domeniu" msdata:parent="domeniu" msdata:child="detaliiProdus" msdata:parentkey="idDomeniu" msdata:childkey="idDomeniu" msprop:Generator_UserRelationName="FK_detaliiProdus_domeniu" msprop:Generator_RelationVarName="relationFK_detaliiProdus_domeniu" msprop:Generator_UserChildTable="detaliiProdus" msprop:Generator_UserParentTable="domeniu" msprop:Generator_ParentPropName="domeniuRow" msprop:Generator_ChildPropName="GetdetaliiProdusRows" />
      <msdata:Relationship name="FK_detaliiProdus_tipProdus" msdata:parent="tipProdus" msdata:child="detaliiProdus" msdata:parentkey="idTipProdus" msdata:childkey="idTipProdus" msprop:Generator_UserRelationName="FK_detaliiProdus_tipProdus" msprop:Generator_RelationVarName="relationFK_detaliiProdus_tipProdus" msprop:Generator_UserChildTable="detaliiProdus" msprop:Generator_UserParentTable="tipProdus" msprop:Generator_ParentPropName="tipProdusRow" msprop:Generator_ChildPropName="GetdetaliiProdusRows" />
      <msdata:Relationship name="FK_exemplar_detaliiProdus" msdata:parent="detaliiProdus" msdata:child="exemplar" msdata:parentkey="idProdus" msdata:childkey="idProdus" msprop:Generator_UserRelationName="FK_exemplar_detaliiProdus" msprop:Generator_RelationVarName="relationFK_exemplar_detaliiProdus" msprop:Generator_UserChildTable="exemplar" msprop:Generator_UserParentTable="detaliiProdus" msprop:Generator_ParentPropName="detaliiProdusRow" msprop:Generator_ChildPropName="GetexemplarRows" />
      <msdata:Relationship name="FK_exemplar_stareProdus" msdata:parent="stareProdus" msdata:child="exemplar" msdata:parentkey="idStareProdus" msdata:childkey="idStareProdus" msprop:Generator_UserRelationName="FK_exemplar_stareProdus" msprop:Generator_RelationVarName="relationFK_exemplar_stareProdus" msprop:Generator_UserChildTable="exemplar" msprop:Generator_UserParentTable="stareProdus" msprop:Generator_ParentPropName="stareProdusRow" msprop:Generator_ChildPropName="GetexemplarRows" />
      <msdata:Relationship name="FK_istoricUtilizatori_utilizator" msdata:parent="utilizator" msdata:child="istoricUtilizatori" msdata:parentkey="idUtilizator" msdata:childkey="idUtilizator" msprop:Generator_UserRelationName="FK_istoricUtilizatori_utilizator" msprop:Generator_RelationVarName="relationFK_istoricUtilizatori_utilizator" msprop:Generator_UserChildTable="istoricUtilizatori" msprop:Generator_UserParentTable="utilizator" msprop:Generator_ParentPropName="utilizatorRow" msprop:Generator_ChildPropName="GetistoricUtilizatoriRows" />
      <msdata:Relationship name="FK_logare_utilizator" msdata:parent="utilizator" msdata:child="logare" msdata:parentkey="idUtilizator" msdata:childkey="idUtilizator" msprop:Generator_UserRelationName="FK_logare_utilizator" msprop:Generator_RelationVarName="relationFK_logare_utilizator" msprop:Generator_UserChildTable="logare" msprop:Generator_UserParentTable="utilizator" msprop:Generator_ParentPropName="utilizatorRow" msprop:Generator_ChildPropName="GetlogareRows" />
      <msdata:Relationship name="FK_penalizare_utilizator" msdata:parent="utilizator" msdata:child="penalizare" msdata:parentkey="idUtilizator" msdata:childkey="idUtilizator" msprop:Generator_UserRelationName="FK_penalizare_utilizator" msprop:Generator_RelationVarName="relationFK_penalizare_utilizator" msprop:Generator_UserChildTable="penalizare" msprop:Generator_UserParentTable="utilizator" msprop:Generator_ParentPropName="utilizatorRow" msprop:Generator_ChildPropName="GetpenalizareRows" />
      <msdata:Relationship name="FK_unitateDeBanda_detaliiProdus" msdata:parent="detaliiProdus" msdata:child="unitateDeBanda" msdata:parentkey="idProdus" msdata:childkey="idProdus" msprop:Generator_UserRelationName="FK_unitateDeBanda_detaliiProdus" msprop:Generator_RelationVarName="relationFK_unitateDeBanda_detaliiProdus" msprop:Generator_UserChildTable="unitateDeBanda" msprop:Generator_UserParentTable="detaliiProdus" msprop:Generator_ParentPropName="detaliiProdusRow" msprop:Generator_ChildPropName="GetunitateDeBandaRows" />
      <msdata:Relationship name="FK_unitateOptica_detaliiProdus" msdata:parent="detaliiProdus" msdata:child="unitateOptica" msdata:parentkey="idProdus" msdata:childkey="idProdus" msprop:Generator_UserRelationName="FK_unitateOptica_detaliiProdus" msprop:Generator_RelationVarName="relationFK_unitateOptica_detaliiProdus" msprop:Generator_UserChildTable="unitateOptica" msprop:Generator_UserParentTable="detaliiProdus" msprop:Generator_ParentPropName="detaliiProdusRow" msprop:Generator_ChildPropName="GetunitateOpticaRows" />
      <msdata:Relationship name="FK_unitateOptica_tipUnitateOptica" msdata:parent="tipUnitateOptica" msdata:child="unitateOptica" msdata:parentkey="idTipUnitateOptica" msdata:childkey="idTipUnitateOptica" msprop:Generator_UserRelationName="FK_unitateOptica_tipUnitateOptica" msprop:Generator_RelationVarName="relationFK_unitateOptica_tipUnitateOptica" msprop:Generator_UserChildTable="unitateOptica" msprop:Generator_UserParentTable="tipUnitateOptica" msprop:Generator_ParentPropName="tipUnitateOpticaRow" msprop:Generator_ChildPropName="GetunitateOpticaRows" />
      <msdata:Relationship name="FK_utilizator_tipUtilizator" msdata:parent="tipUtilizator" msdata:child="utilizator" msdata:parentkey="idTipUtilizator" msdata:childkey="idTipUtilizator" msprop:Generator_UserRelationName="FK_utilizator_tipUtilizator" msprop:Generator_RelationVarName="relationFK_utilizator_tipUtilizator" msprop:Generator_UserChildTable="utilizator" msprop:Generator_UserParentTable="tipUtilizator" msprop:Generator_ParentPropName="tipUtilizatorRow" msprop:Generator_ChildPropName="GetutilizatorRows" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>